/*
Navicat SQL Server Data Transfer

Source Server         : 47.98.139.136
Source Server Version : 105000
Source Host           : 47.98.139.136:1433
Source Database       : ST12
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 105000
File Encoding         : 65001

Date: 2018-05-20 21:43:58
*/

if EXISTS(SELECT * FROM sysdatabases WHERE name='ST12')  
  DROP DATABASE ST12

GO

create database ST12;
GO

USE ST12;
GO
-- ----------------------------
-- Table structure for AuditReport
-- ----------------------------
DROP TABLE [dbo].[AuditReport]
GO
CREATE TABLE [dbo].[AuditReport] (
[车牌号] nvarchar(50) NULL ,
[申请时间] nvarchar(50) NULL ,
[申请人] nvarchar(50) NULL ,
[审批结果] nvarchar(50) NULL 
)


GO

-- ----------------------------
-- Records of AuditReport
-- ----------------------------
INSERT INTO [dbo].[AuditReport] ([车牌号], [申请时间], [申请人], [审批结果]) VALUES (N'X001', N'2018-05-06 21:31:21', N'lingdao', N'通过')
GO
GO
INSERT INTO [dbo].[AuditReport] ([车牌号], [申请时间], [申请人], [审批结果]) VALUES (N'X002', N'2018-05-06 21:44:47', N'lingdao', N'通过')
GO
GO
INSERT INTO [dbo].[AuditReport] ([车牌号], [申请时间], [申请人], [审批结果]) VALUES (N'X001', N'2018-05-06 21:50:24', N'lingdao', N'未通过')
GO
GO
INSERT INTO [dbo].[AuditReport] ([车牌号], [申请时间], [申请人], [审批结果]) VALUES (N'X001', N'2018-05-20 16:39:00', N'xxx', N'拒绝-mmp')
GO
GO

-- ----------------------------
-- Table structure for CarLines
-- ----------------------------
DROP TABLE [dbo].[CarLines]
GO
CREATE TABLE [dbo].[CarLines] (
[车牌号] nvarchar(50) NULL ,
[始发地] nvarchar(50) NULL ,
[目的地] nvarchar(50) NULL ,
[定金] int NULL ,
[票价] int NULL 
)


GO

-- ----------------------------
-- Records of CarLines
-- ----------------------------
INSERT INTO [dbo].[CarLines] ([车牌号], [始发地], [目的地], [定金], [票价]) VALUES (N'X001', N'连云港', N'苏州', N'20', N'120')
GO
GO
INSERT INTO [dbo].[CarLines] ([车牌号], [始发地], [目的地], [定金], [票价]) VALUES (N'X002', N'南京', N'连云港', N'40', N'130')
GO
GO

-- ----------------------------
-- Table structure for Cars
-- ----------------------------
DROP TABLE [dbo].[Cars]
GO
CREATE TABLE [dbo].[Cars] (
[车牌号] nvarchar(50) NOT NULL ,
[车类型] nvarchar(50) NULL ,
[车身颜色] nvarchar(50) NULL ,
[汽车品牌] nvarchar(50) NULL ,
[座位数] nvarchar(50) NULL 
)


GO

-- ----------------------------
-- Records of Cars
-- ----------------------------
INSERT INTO [dbo].[Cars] ([车牌号], [车类型], [车身颜色], [汽车品牌], [座位数]) VALUES (N'X001', N'大巴', N'蓝', N'大众', N'40')
GO
GO
INSERT INTO [dbo].[Cars] ([车牌号], [车类型], [车身颜色], [汽车品牌], [座位数]) VALUES (N'X002', N'大巴', N'黄', N'北汽福田', N'40')
GO
GO
INSERT INTO [dbo].[Cars] ([车牌号], [车类型], [车身颜色], [汽车品牌], [座位数]) VALUES (N'X003', N'大巴', N'黄', N'桂林大宇', N'30')
GO
GO
INSERT INTO [dbo].[Cars] ([车牌号], [车类型], [车身颜色], [汽车品牌], [座位数]) VALUES (N'X004', N'大巴', N'蓝', N'金旅', N'42')
GO
GO

-- ----------------------------
-- Table structure for CarsAccident
-- ----------------------------
DROP TABLE [dbo].[CarsAccident]
GO
CREATE TABLE [dbo].[CarsAccident] (
[ID] int NOT NULL IDENTITY(1,1) ,
[车牌号] nvarchar(50) NOT NULL ,
[事故日期] datetime NULL ,
[事故原因] nvarchar(50) NULL ,
[事故结果] nvarchar(50) NULL ,
[罚金] money NULL 
)


GO
DBCC CHECKIDENT(N'[dbo].[CarsAccident]', RESEED, 3)
GO

-- ----------------------------
-- Records of CarsAccident
-- ----------------------------
SET IDENTITY_INSERT [dbo].[CarsAccident] ON
GO
INSERT INTO [dbo].[CarsAccident] ([ID], [车牌号], [事故日期], [事故原因], [事故结果], [罚金]) VALUES (N'1', N'X001', N'2014-05-09 00:00:00.000', N'两车碰撞', N'司机扣工资', N'1000.0000')
GO
GO
INSERT INTO [dbo].[CarsAccident] ([ID], [车牌号], [事故日期], [事故原因], [事故结果], [罚金]) VALUES (N'2', N'X002', N'2014-06-02 00:00:00.000', N'撞伤行人', N'司机被停职', N'500.0000')
GO
GO
INSERT INTO [dbo].[CarsAccident] ([ID], [车牌号], [事故日期], [事故原因], [事故结果], [罚金]) VALUES (N'3', N'X004', N'2014-06-03 00:00:00.000', N'坠桥', N'司机受伤在医院', N'5000.0000')
GO
GO
SET IDENTITY_INSERT [dbo].[CarsAccident] OFF
GO

-- ----------------------------
-- Table structure for CarsBreakLaw
-- ----------------------------
DROP TABLE [dbo].[CarsBreakLaw]
GO
CREATE TABLE [dbo].[CarsBreakLaw] (
[ID] int NOT NULL IDENTITY(1,1) ,
[车牌号] nvarchar(50) NOT NULL ,
[违章日期] datetime NOT NULL ,
[违章原因] nvarchar(50) NOT NULL ,
[违章罚金] money NOT NULL ,
[备注] nvarchar(50) NULL 
)


GO
DBCC CHECKIDENT(N'[dbo].[CarsBreakLaw]', RESEED, 3)
GO

-- ----------------------------
-- Records of CarsBreakLaw
-- ----------------------------
SET IDENTITY_INSERT [dbo].[CarsBreakLaw] ON
GO
INSERT INTO [dbo].[CarsBreakLaw] ([ID], [车牌号], [违章日期], [违章原因], [违章罚金], [备注]) VALUES (N'1', N'X002', N'2014-05-08 00:00:00.000', N'随意并线', N'200.0000', null)
GO
GO
INSERT INTO [dbo].[CarsBreakLaw] ([ID], [车牌号], [违章日期], [违章原因], [违章罚金], [备注]) VALUES (N'2', N'X002', N'2014-08-09 00:00:00.000', N'闯红灯', N'200.0000', null)
GO
GO
INSERT INTO [dbo].[CarsBreakLaw] ([ID], [车牌号], [违章日期], [违章原因], [违章罚金], [备注]) VALUES (N'3', N'X003', N'2014-10-05 00:00:00.000', N'逆线', N'500.0000', null)
GO
GO
SET IDENTITY_INSERT [dbo].[CarsBreakLaw] OFF
GO

-- ----------------------------
-- Table structure for CarsRepair
-- ----------------------------
DROP TABLE [dbo].[CarsRepair]
GO
CREATE TABLE [dbo].[CarsRepair] (
[ID] int NOT NULL IDENTITY(1,1) ,
[车牌号] nvarchar(50) NOT NULL ,
[维修日期] datetime NULL ,
[故障原因] nvarchar(50) NULL ,
[维修结果] nvarchar(50) NULL 
)


GO
DBCC CHECKIDENT(N'[dbo].[CarsRepair]', RESEED, 5)
GO

-- ----------------------------
-- Records of CarsRepair
-- ----------------------------
SET IDENTITY_INSERT [dbo].[CarsRepair] ON
GO
INSERT INTO [dbo].[CarsRepair] ([ID], [车牌号], [维修日期], [故障原因], [维修结果]) VALUES (N'1', N'X001', N'2014-05-08 00:00:00.000', N'漏气', N'维修成功')
GO
GO
INSERT INTO [dbo].[CarsRepair] ([ID], [车牌号], [维修日期], [故障原因], [维修结果]) VALUES (N'2', N'X002', N'2014-04-12 00:00:00.000', N'方向盘坏', N'维修成功')
GO
GO
INSERT INTO [dbo].[CarsRepair] ([ID], [车牌号], [维修日期], [故障原因], [维修结果]) VALUES (N'3', N'X003', N'2015-09-09 00:00:00.000', N'要换机油', N'更换成功')
GO
GO
INSERT INTO [dbo].[CarsRepair] ([ID], [车牌号], [维修日期], [故障原因], [维修结果]) VALUES (N'4', N'X001', N'2014-06-07 00:00:00.000', N'玻璃破碎', N'维修成功')
GO
GO
INSERT INTO [dbo].[CarsRepair] ([ID], [车牌号], [维修日期], [故障原因], [维修结果]) VALUES (N'5', N'X003', null, N'保养', null)
GO
GO
SET IDENTITY_INSERT [dbo].[CarsRepair] OFF
GO

-- ----------------------------
-- Table structure for CarsRun
-- ----------------------------
DROP TABLE [dbo].[CarsRun]
GO
CREATE TABLE [dbo].[CarsRun] (
[ID] int NOT NULL IDENTITY(1,1) ,
[车牌号] nvarchar(50) NOT NULL ,
[运营日期] datetime NOT NULL ,
[员工编号] nvarchar(50) NOT NULL ,
[状态记录] nvarchar(50) NULL 
)


GO
DBCC CHECKIDENT(N'[dbo].[CarsRun]', RESEED, 16)
GO

-- ----------------------------
-- Records of CarsRun
-- ----------------------------
SET IDENTITY_INSERT [dbo].[CarsRun] ON
GO
INSERT INTO [dbo].[CarsRun] ([ID], [车牌号], [运营日期], [员工编号], [状态记录]) VALUES (N'1', N'X002', N'2014-01-05 00:00:00.000', N'E01', N'良好')
GO
GO
INSERT INTO [dbo].[CarsRun] ([ID], [车牌号], [运营日期], [员工编号], [状态记录]) VALUES (N'2', N'X002', N'2014-01-05 00:00:00.000', N'E02', N'良好')
GO
GO
INSERT INTO [dbo].[CarsRun] ([ID], [车牌号], [运营日期], [员工编号], [状态记录]) VALUES (N'3', N'X003', N'2014-01-05 00:00:00.000', N'E03', N'良好')
GO
GO
INSERT INTO [dbo].[CarsRun] ([ID], [车牌号], [运营日期], [员工编号], [状态记录]) VALUES (N'4', N'X004', N'2014-01-05 00:00:00.000', N'E04', N'良好')
GO
GO
INSERT INTO [dbo].[CarsRun] ([ID], [车牌号], [运营日期], [员工编号], [状态记录]) VALUES (N'5', N'X001', N'2014-01-12 00:00:00.000', N'E02', N'良好')
GO
GO
INSERT INTO [dbo].[CarsRun] ([ID], [车牌号], [运营日期], [员工编号], [状态记录]) VALUES (N'6', N'X002', N'2014-01-12 00:00:00.000', N'E02', N'良好')
GO
GO
INSERT INTO [dbo].[CarsRun] ([ID], [车牌号], [运营日期], [员工编号], [状态记录]) VALUES (N'7', N'X003', N'2014-01-13 00:00:00.000', N'E03', N'良好')
GO
GO
INSERT INTO [dbo].[CarsRun] ([ID], [车牌号], [运营日期], [员工编号], [状态记录]) VALUES (N'8', N'X004', N'2014-01-15 00:00:00.000', N'E04', N'良好')
GO
GO
INSERT INTO [dbo].[CarsRun] ([ID], [车牌号], [运营日期], [员工编号], [状态记录]) VALUES (N'9', N'X003', N'2014-01-16 00:00:00.000', N'E04', N'良好')
GO
GO
INSERT INTO [dbo].[CarsRun] ([ID], [车牌号], [运营日期], [员工编号], [状态记录]) VALUES (N'10', N'X002', N'2014-01-17 00:00:00.000', N'E04', N'良好')
GO
GO
INSERT INTO [dbo].[CarsRun] ([ID], [车牌号], [运营日期], [员工编号], [状态记录]) VALUES (N'11', N'X003', N'2014-01-18 00:00:00.000', N'E01', N'良好')
GO
GO
INSERT INTO [dbo].[CarsRun] ([ID], [车牌号], [运营日期], [员工编号], [状态记录]) VALUES (N'12', N'X002', N'2018-05-05 00:00:00.000', N'E01', N'良好')
GO
GO
INSERT INTO [dbo].[CarsRun] ([ID], [车牌号], [运营日期], [员工编号], [状态记录]) VALUES (N'14', N'X001', N'2018-05-10 17:54:04.000', N'E01', null)
GO
GO
INSERT INTO [dbo].[CarsRun] ([ID], [车牌号], [运营日期], [员工编号], [状态记录]) VALUES (N'16', N'X001', N'2018-05-20 21:42:25.000', N'E04', null)
GO
GO
SET IDENTITY_INSERT [dbo].[CarsRun] OFF
GO

-- ----------------------------
-- Table structure for CarsYearAudit
-- ----------------------------
DROP TABLE [dbo].[CarsYearAudit]
GO
CREATE TABLE [dbo].[CarsYearAudit] (
[ID] int NOT NULL IDENTITY(1,1) ,
[车牌号] nvarchar(50) NOT NULL ,
[年审年份] int NOT NULL ,
[年审日期] datetime NULL ,
[年审通过] bit NULL ,
[备注] nvarchar(50) NULL 
)


GO
DBCC CHECKIDENT(N'[dbo].[CarsYearAudit]', RESEED, 6)
GO

-- ----------------------------
-- Records of CarsYearAudit
-- ----------------------------
SET IDENTITY_INSERT [dbo].[CarsYearAudit] ON
GO
INSERT INTO [dbo].[CarsYearAudit] ([ID], [车牌号], [年审年份], [年审日期], [年审通过], [备注]) VALUES (N'1', N'X002', N'2017', N'2017-08-08 00:00:00.000', N'1', null)
GO
GO
INSERT INTO [dbo].[CarsYearAudit] ([ID], [车牌号], [年审年份], [年审日期], [年审通过], [备注]) VALUES (N'2', N'X004', N'2018', N'2018-04-05 00:00:00.000', N'1', N'')
GO
GO
INSERT INTO [dbo].[CarsYearAudit] ([ID], [车牌号], [年审年份], [年审日期], [年审通过], [备注]) VALUES (N'6', N'X002', N'2018', null, null, null)
GO
GO
SET IDENTITY_INSERT [dbo].[CarsYearAudit] OFF
GO

-- ----------------------------
-- Table structure for CarTickets
-- ----------------------------
DROP TABLE [dbo].[CarTickets]
GO
CREATE TABLE [dbo].[CarTickets] (
[线路] nvarchar(255) NULL ,
[总座位数] int NULL ,
[预定人数] int NULL ,
[定金] int NULL ,
[票价] int NULL ,
[班次编号] int NOT NULL IDENTITY(1,1) ,
[是否发车] bit NULL DEFAULT ((0)) ,
[车牌] nvarchar(50) NULL 
)


GO
DBCC CHECKIDENT(N'[dbo].[CarTickets]', RESEED, 4)
GO

-- ----------------------------
-- Records of CarTickets
-- ----------------------------
SET IDENTITY_INSERT [dbo].[CarTickets] ON
GO
INSERT INTO [dbo].[CarTickets] ([线路], [总座位数], [预定人数], [定金], [票价], [班次编号], [是否发车], [车牌]) VALUES (N'连云港-苏州', N'40', N'1', N'20', N'100', N'2', N'1', N'X001')
GO
GO
INSERT INTO [dbo].[CarTickets] ([线路], [总座位数], [预定人数], [定金], [票价], [班次编号], [是否发车], [车牌]) VALUES (N'南京-连云港', N'40', N'2', N'40', N'130', N'3', N'0', N'X002')
GO
GO
INSERT INTO [dbo].[CarTickets] ([线路], [总座位数], [预定人数], [定金], [票价], [班次编号], [是否发车], [车牌]) VALUES (N'连云港-苏州', N'40', N'2', N'20', N'120', N'4', N'0', N'X001')
GO
GO
SET IDENTITY_INSERT [dbo].[CarTickets] OFF
GO

-- ----------------------------
-- Table structure for CharteredCar
-- ----------------------------
DROP TABLE [dbo].[CharteredCar]
GO
CREATE TABLE [dbo].[CharteredCar] (
[车牌] nvarchar(50) NULL ,
[路线] nvarchar(50) NULL ,
[座位数] int NULL ,
[定金] int NULL ,
[待付] int NULL ,
[预定人] nvarchar(50) NULL ,
[联系方式] nvarchar(50) NULL ,
[是否发车] bit NULL ,
[预定编号] int NOT NULL IDENTITY(1,1) 
)


GO
DBCC CHECKIDENT(N'[dbo].[CharteredCar]', RESEED, 2)
GO

-- ----------------------------
-- Records of CharteredCar
-- ----------------------------
SET IDENTITY_INSERT [dbo].[CharteredCar] ON
GO
INSERT INTO [dbo].[CharteredCar] ([车牌], [路线], [座位数], [定金], [待付], [预定人], [联系方式], [是否发车], [预定编号]) VALUES (N'X001', N'连云港-苏州', N'20', N'400', N'0', N'吴陆', N'13812345678', N'1', N'1')
GO
GO
INSERT INTO [dbo].[CharteredCar] ([车牌], [路线], [座位数], [定金], [待付], [预定人], [联系方式], [是否发车], [预定编号]) VALUES (N'X002', N'南京-连云港', N'30', N'1200', N'2700', N'秦漆', N'13812345678', N'0', N'2')
GO
GO
SET IDENTITY_INSERT [dbo].[CharteredCar] OFF
GO

-- ----------------------------
-- Table structure for dtproperties
-- ----------------------------
DROP TABLE [dbo].[dtproperties]
GO
CREATE TABLE [dbo].[dtproperties] (
[id] int NOT NULL IDENTITY(1,1) ,
[objectid] int NULL ,
[property] varchar(64) NOT NULL ,
[value] varchar(255) NULL ,
[uvalue] nvarchar(255) NULL ,
[lvalue] image NULL ,
[version] int NOT NULL DEFAULT (0) 
)


GO
DBCC CHECKIDENT(N'[dbo].[dtproperties]', RESEED, 7)
GO

-- ----------------------------
-- Records of dtproperties
-- ----------------------------
SET IDENTITY_INSERT [dbo].[dtproperties] ON
GO
INSERT INTO [dbo].[dtproperties] ([id], [objectid], [property], [value], [uvalue], [lvalue], [version]) VALUES (N'1', N'1', N'DtgSchemaOBJECT', null, null, null, N'0')
GO
GO
INSERT INTO [dbo].[dtproperties] ([id], [objectid], [property], [value], [uvalue], [lvalue], [version]) VALUES (N'2', N'1', N'DtgSchemaGUID', N'{EA3E6268-D998-11CE-9454-00AA00A3F36E}', N'{EA3E6268-D998-11CE-9454-00AA00A3F36E}', null, N'0')
GO
GO
INSERT INTO [dbo].[dtproperties] ([id], [objectid], [property], [value], [uvalue], [lvalue], [version]) VALUES (N'3', N'1', N'DtgSchemaNAME', N'图表1', N'图表1', null, N'0')
GO
GO
INSERT INTO [dbo].[dtproperties] ([id], [objectid], [property], [value], [uvalue], [lvalue], [version]) VALUES (N'4', N'1', N'DtgDSRefBYTES', N'954', N'954', null, N'3')
GO
GO
INSERT INTO [dbo].[dtproperties] ([id], [objectid], [property], [value], [uvalue], [lvalue], [version]) VALUES (N'5', N'1', N'DtgDSRefDATA', null, null, 0xDBE6B0E91C81D011AD5100A0C90F57390000020080260199F8C7CF010202000010480500000000000000000000000000000000003A020000500072006F00760069006400650072003D00530051004C004F004C004500440042002E0031003B0049006E00740065006700720061007400650064002000530065006300750072006900740079003D0053005300500049003B005000650072007300690073007400200053006500630075007200690074007900200049006E0066006F003D00460061006C00730065003B0049006E0069007400690061006C00200043006100740061006C006F0067003D0053005400310032003B004400610074006100200053006F0075007200630065003D002E005C006700730071006C003B005500730065002000500072006F00630065006400750072006500200066006F007200200050007200650070006100720065003D0031003B004100750074006F0020005400720061006E0073006C006100740065003D0054007200750065003B005000610063006B00650074002000530069007A0065003D0034003000390036003B0057006F0072006B00730074006100740069006F006E002000490044003D0055005300450052002D00320030003100360031003100310037004D0042003B00550073006500200045006E006300720079007000740069006F006E00200066006F007200200044006100740061003D00460061006C00730065003B0054006100670020007700690074006800200063006F006C0075006D006E00200063006F006C006C006100740069006F006E0020007700680065006E00200070006F0073007300690062006C0065003D00460061006C007300650000000080050008000000FE56688831000000000226000A0000004300610072007300000008000000640062006F000000000226001A00000043006100720073004100630063006900640065006E007400000008000000640062006F000000000226001A000000430061007200730042007200650061006B004C0061007700000008000000640062006F00000000022600160000004300610072007300520065007000610069007200000008000000640062006F00000000022600100000004300610072007300520075006E00000008000000640062006F000000000226001C0000004300610072007300590065006100720041007500640069007400000008000000640062006F000000000226001200000045006D0070006C006F00790065006500000008000000640062006F000000000224000600000028753762000008000000640062006F000000, N'3')
GO
GO
INSERT INTO [dbo].[dtproperties] ([id], [objectid], [property], [value], [uvalue], [lvalue], [version]) VALUES (N'6', N'1', N'DtgSchemaBYTES', N'17920', N'17920', null, N'3')
GO
GO
INSERT INTO [dbo].[dtproperties] ([id], [objectid], [property], [value], [uvalue], [lvalue], [version]) VALUES (N'7', N'1', N'DtgSchemaDATA', null, null, 0xD0CF11E0A1B11AE1000000000000000000000000000000003E000300FEFF0900060000000000000000000000010000000100000000000000001000000200000001000000FEFFFFFF0000000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFDFFFFFF14000000FEFFFFFF0400000005000000060000002000000008000000090000000A0000000B0000000C0000000D0000000E0000000F00000010000000110000001200000013000000FEFFFFFFFEFFFFFF160000001700000018000000190000001A0000001B0000001C0000001D0000001E0000001F000000FEFFFFFF21000000FEFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF52006F006F007400200045006E00740072007900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000016000500FFFFFFFFFFFFFFFF020000000000000000000000000000000000000000000000000000000000000070E10599F8C7CF0103000000000C0000000000006600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000201FFFFFFFFFFFFFFFFFFFFFFFF0000000000000000000000000000000000000000000000000000000000000000000000000000000012070000000000006F000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000040002010100000004000000FFFFFFFF000000000000000000000000000000000000000000000000000000000000000000000000070000005C19000000000000010043006F006D0070004F0062006A0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012000201FFFFFFFFFFFFFFFFFFFFFFFF0000000000000000000000000000000000000000000000000000000000000000000000001D0000005F000000000000000100000002000000030000000400000005000000060000000700000008000000090000000A0000000B0000000C0000000D0000000E0000000F000000100000001100000012000000130000001400000015000000160000001700000018000000190000001A0000001B0000001C000000FEFFFFFF1E000000FEFFFFFFFEFFFFFF2100000022000000230000002400000025000000260000002700000028000000290000002A0000002B0000002C0000002D0000002E000000FEFFFFFFFEFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF000434000A1E500C05000080140000000F00FFFF6E00000014000000007D0000335300001F380000FB5B0000EC6D000073090000BEDAFFFFDE805B10F195D011B0A000AA00BDCB5C00001000010000000600008053797374656D16000300000038002B00000009000000D9E6B0E91C81D011AD5100A0C90F5739F43B7F847F61C74385352986E1D552F8A0327DB2D86295428D98273C25A2DA2D00002C0043200000000000000000000053444DD2011FD1118E63006097D2DF48CBBE05E22D69D2118D1B00600831977900002C0043200000000000000000000051444DD2011FD1118E63006097D2DF48CBBE05E22D69D2118D1B00600831977914000000100600000094010F00002C00A509000008000080010000009A0200000080000004000080436F6E74726F6C31220B00006CEEFFFF4361727300003400A50900000800008002000000AA020000008000000C000080436F6E74726F6C325C2B0000A0F6FFFF436172734163636964656E7400003400A50900000800008003000000AA020000008000000C000080436F6E74726F6C335C2B0000DC05000043617273427265616B4C617700003400A50900000800008004000000A6020000008000000A000080436F6E74726F6C345C2B0000ACDBFFFF43617273526570616972617700003000A50900000800008005000000A00200000080000007000080436F6E74726F6C355C2B000026E9FFFF4361727352756E3500003800A50900000800008006000000AC020000008000000D000080436F6E74726F6C365C2B000018150000436172735965617241756469746BC10F00003000A50900000800008007000000A20200000080000008000080436F6E74726F6C37B80B0000F8F8FFFF456D706C6F79656500002C00A50900000800008008000000960200000080000004000000436F6E74726F6C38B80B0000580200002875376200007400A5090000080000800900000052000000018000004C000000436F6E74726F6C391D1E00002DEFFFFF1C2043006100720073001D208C541C204300610072007300520075006E001D204B4EF49584767351FB7C1C2046004B005F004300610072007300520075006E005F0043006100720073001D2000002C00B5010000090000800A000000310000004F00000002800000436F6E74726F6C31307564694020000073F1FFFF00008C00A5090000090000800B000000620000000180000060000000436F6E74726F6C31317564691D1E000059F0FFFF1C2043006100720073001D208C541C2043006100720073004100630063006900640065006E0074001D204B4EF49584767351FB7C1C2046004B005F0043006100720073004100630063006900640065006E0074005F0043006100720073001D2000002C00B5010000090000800C000000310000005900000002800000436F6E74726F6C3132756469D81D0000CDF8FFFF00008C00A5090000090000800D000000620000000180000060000000436F6E74726F6C31337564691D1E000085F1FFFF1C2043006100720073001D208C541C20430061007200730042007200650061006B004C00610077001D204B4EF49584767351FB7C1C2046004B005F00430061007200730042007200650061006B004C00610077005F0043006100720073001D2000002C00B5010000090000800E000000310000005900000002800000436F6E74726F6C3134756469D1150000F0FFFFFF00009000A5090000090000800F000000620000000180000064000000436F6E74726F6C31357564691D1E000073F4FFFF1C2043006100720073001D208C541C2043006100720073005900650061007200410075006400690074001D204B4EF49584767351FB7C1C2046004B005F0043006100720073005900650061007200410075006400690074005F0043006100720073001D2000002C00B50100000900008010000000310000005B00000002800000436F6E74726F6C313675646949140000290A000000008800A5090000090000801100000062000000018000005C000000436F6E74726F6C3137756469B31E000037F2FFFF1C2045006D0070006C006F007900650065001D208C541C204300610072007300520075006E001D204B4EF49584767351FB7C1C2046004B005F004300610072007300520075006E005F0045006D0070006C006F007900650065001D2000002C00B50100000900008012000000310000005700000002800000436F6E74726F6C31387564697428000077F9FFFF00008400A50900000900008013000000620000000180000058000000436F6E74726F6C31397564691D1E0000BDE4FFFF1C2043006100720073001D208C541C2043006100720073005200650070006100690072001D204B4EF49584767351FB7C1C2046004B005F0043006100720073005200650070006100690072005F0043006100720073001D2000002C00B50100000900008014000000310000005500000002800000436F6E74726F6C32307564694C26000097EBFFFF000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100FEFF030A0000FFFFFFFF00000000000000000000000000000000170000004D6963726F736F66742044445320466F726D20322E300010000000456D626564646564204F626A6563740000000000F439B271000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010003000000000000000C0000000B0000004E61BC000000000000000000000000000000000000000000000000000000000000000000000000000000000000002143341208000000271400002A08000078563412070000001401000043006100720073000000650070006100690072000000000000000000000000000B009A7600001600FFFF0000ECC413001500000000000000000000000000000000000000000000000000000000000000000000000B009A7600001600FFFF0000ECC4130022000000000000000000000000000000000000000000000000000000000000000000000003009A76000016001E000000ECC413007F00000000000000000000000000000000000000000000000000000000000000000000000B009A7600001600FFFF0000ECC413005A0000000000000000000000000000000000000000000000000000000000000000000000FF0000004CFFFFFF0100000005000000540000002C0000002C0000002C000000340000000000000000000000562F0000D9100000000000002D010000070000000C000000070000001C010000F708000053070000390300000B040000D0020000DD04000018060000A203000018060000BC070000460500000000000001000000271400002A08000000000000030000000300000002000000020000001C0100001C0900000000000001000000271400002A08000000000000030000000300000002000000020000001C010000F7080000010000000000000027140000E502000000000000000000000000000002000000020000001C010000F7080000000000000000000055320000BC19000000000000000000000D00000004000000040000001C010000F70800009B0A00008106000078563412040000005200000001000000010000000B000000000000000100000002000000030000000400000005000000060000000700000008000000090000000A00000004000000640062006F0000000500000043006100720073000000214334120800000033140000900E000078563412070000001401000043006100720073004100630063006900640065006E00740000000000000000000B009A7600001600FFFF0000ECC413001500000000000000000000000000000000000000000000000000000000000000000000000B009A7600001600FFFF0000ECC4130022000000000000000000000000000000000000000000000000000000000000000000000003009A76000016001E000000ECC413007F00000000000000000000000000000000000000000000000000000000000000000000000B009A7600001600FFFF0000ECC413005A0000000000000000000000000000000000000000000000000000000000000000000000FF0000004CFFFFFF0100000005000000540000002C0000002C0000002C000000340000000000000000000000562F00009B120000000000002D010000080000000C000000070000001C010000F708000053070000390300000B040000D0020000DD04000018060000A203000018060000BC07000046050000000000000100000033140000900E000000000000060000000600000002000000020000001C0100001C090000000000000100000027140000700D000000000000060000000600000002000000020000001C010000F7080000010000000000000027140000E502000000000000000000000000000002000000020000001C010000F7080000000000000000000055320000BC19000000000000000000000D00000004000000040000001C010000F70800009B0A00008106000078563412040000006200000001000000010000000B000000000000000100000002000000030000000400000005000000060000000700000008000000090000000A00000004000000640062006F0000000D00000043006100720073004100630063006900640065006E0074000000214334120800000033140000A90E0000785634120700000014010000430061007200730042007200650061006B004C006100770000000000000000000B009A7600001600FFFF0000B0D813001500000000000000000000000000000000000000000000000000000000000000000000000B009A7600001600FFFF0000B0D8130022000000000000000000000000000000000000000000000000000000000000000000000003009A76000016001E000000B0D813007F00000000000000000000000000000000000000000000000000000000000000000000000B009A7600001600FFFF0000B0D813005A0000000000000000000000000000000000000000000000000000000000000000000000FF0000004CFFFFFF0100000005000000540000002C0000002C0000002C000000340000000000000000000000562F00009B120000000000002D010000080000000C000000070000001C010000F708000053070000390300000B040000D0020000DD04000018060000A203000018060000BC07000046050000000000000100000033140000A90E000000000000060000000600000002000000020000001C0100001C090000000000000100000027140000700D000000000000060000000600000002000000020000001C010000F7080000010000000000000027140000E502000000000000000000000000000002000000020000001C010000F7080000000000000000000055320000BC19000000000000000000000D00000004000000040000001C010000F70800009B0A00008106000078563412040000006200000001000000010000000B000000000000000100000002000000030000000400000005000000060000000700000008000000090000000A00000004000000640062006F0000000D000000430061007200730042007200650061006B004C0061007700000021433412080000001B140000E00C000078563412070000001401000043006100720073005200650070006100690072000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF52006F006F007400200045006E00740072007900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000016000500FFFFFFFFFFFFFFFFFFFFFFFF000000000000000000000000000000000000000000000000000000000000000000000000FEFFFFFF00000000000000000000000000000000000000000000000000000000FF0000004CFFFFFF0100000005000000540000002C0000002C0000002C000000340000000000000000000000562F0000D9100000000000002D010000070000000C000000070000001C010000F708000053070000390300000B040000D0020000DD04000018060000A203000018060000BC0700004605000000000000010000001B140000E00C000000000000050000000500000002000000020000001C0100000E090000000000000100000027140000AE0B000000000000050000000500000002000000020000001C010000F7080000010000000000000027140000E502000000000000000000000000000002000000020000001C010000F7080000000000000000000055320000BC19000000000000000000000D00000004000000040000001C010000F70800009B0A00008106000078563412040000005E00000001000000010000000B000000000000000100000002000000030000000400000005000000060000000700000008000000090000000A00000004000000640062006F0000000B00000043006100720073005200650070006100690072000000214334120800000033140000DF0C00007856341207000000140100004300610072007300520075006E000000801E620E801E620E01000000D807610E0000000007002C00520108028C15B301080000000F0000000000000043006500720065006200720061006C0000000000000000000000000000000000040033005B000C02801E620EB821640E9865620E010000003008610E00000000070037005F0108028C15B3010B0000000F0000000000000043006F00620062006C006500730074006F006E0065000000000000000000000004003E0044000C02402D620EA052620EC0D4620E010000008808610E000000000400500048010C02083D4F0E20694F0E883C700C00000000B0524F0EFF0000004CFFFFFF0100000005000000540000002C0000002C0000002C000000340000000000000000000000562F0000D9100000000000002D010000070000000C000000070000001C010000F708000053070000390300000B040000D0020000DD04000018060000A203000018060000BC07000046050000000000000100000033140000DF0C000000000000050000000500000002000000020000001C0100001C090000000000000100000027140000AE0B000000000000050000000500000002000000020000001C010000F7080000010000000000000027140000E502000000000000000000000000000002000000020000001C010000F7080000000000000000000055320000BC19000000000000000000000D00000004000000040000001C010000F70800009B0A00008106000078563412040000005800000001000000010000000B000000000000000100000002000000030000000400000005000000060000000700000008000000090000000A00000004000000640062006F000000080000004300610072007300520075006E000000214334120800000027140000700D0000785634120700000014010000430061007200730059006500610072004100750064006900740000007F83CCFFECECF8FFEBEBEBFFAFAFAFFF1C1C1CFF4B4B4BFFEBEBEBFF272727FF2F2F2FFFF7F7F7FFF9F9F9FFB8BAE4FF474CB0FF454DCFFFF9F9F9FF4247ADFF9296D4FFEEF0F9FFEBEBEBFFE5E5E5FF272727FF202020FFE5E5E5FF2F2F2FFF2F2F2FFFF9F9F9FFF9F9F9FFC7C8EAFF4B51B2FF454DCFFF575BCFFF4449AFFF999DD6FFEEF0F9FF818181FF363636FF202020FF1C1C1CFF272727FF363636FF707070FFF9F9F9FFF9F9F9FFC7C8EAFF4B51B2FF454DCFFFF9F9F9FF4247ADFFA1A4D9FFF3F4FAFFEBEBEBFFEBEBEBFF939393FFFF0000004CFFFFFF0100000005000000540000002C0000002C0000002C000000340000000000000000000000562F00009B120000000000002D010000080000000C000000070000001C010000F708000053070000390300000B040000D0020000DD04000018060000A203000018060000BC07000046050000000000000100000027140000700D000000000000060000000600000002000000020000001C0100001C090000000000000100000027140000700D000000000000060000000600000002000000020000001C010000F7080000010000000000000027140000E502000000000000000000000000000002000000020000001C010000F7080000000000000000000055320000BC19000000000000000000000D00000004000000040000001C010000F70800009B0A00008106000078563412040000006400000001000000010000000B000000000000000100000002000000030000000400000005000000060000000700000008000000090000000A00000004000000640062006F0000000E000000430061007200730059006500610072004100750064006900740000002143341208000000271400002A08000078563412070000001401000045006D0070006C006F007900650065000000000068100000FA170000FE10000000000000FE100000FA170000941100000000000094110000FA1700002A120000000000002A120000FA170000C012000000000000C0120000FA170000561300000000000056130000FA17000000000000960000002714000096000000000000002C010000271400002C01000000000000C201000027140000C20100000000000058020000271400005802000000000000EE02000027140000EE02000000000000840300002714000084030000000000001A040000271400001A04000000000000B004000027140000B004000000000000FF0000004CFFFFFF0100000005000000540000002C0000002C0000002C000000340000000000000000000000562F0000D9100000000000002D010000070000000C000000070000001C010000F708000053070000390300000B040000D0020000DD04000018060000A203000018060000BC070000460500000000000001000000271400002A08000000000000030000000300000002000000020000001C0100000E0900000000000001000000271400002A08000000000000030000000300000002000000020000001C010000F7080000010000000000000027140000E502000000000000000000000000000002000000020000001C010000F7080000000000000000000055320000BC19000000000000000000000D00000004000000040000001C010000F70800009B0A00008106000078563412040000005A00000001000000010000000B000000000000000100000002000000030000000400000005000000060000000700000008000000090000000A00000004000000640062006F0000000900000045006D0070006C006F00790065006500000021433412080000001C1400009D1500007856341207000000140100002875376200000000FA170000681000000000000068100000FA170000FE1000000000000000000000000000000C0000000000000094110000FA1700002A120000000000002A120000FA170000C01200000000000000000000000000000C0000000000000056130000FA17000000000000960000002714000096000000000000002C01000000000000000000000C0000000000000027140000C20100000000000058020000271400005802000000000000EE02000000000000000000000C000000000000002714000084030000000000001A040000271400001A04000000000000B004000000000000000000000C000000FF0000004CFFFFFF0100000005000000540000002C0000002C0000002C000000340000000000000000000000562F00009B120000000000002D010000080000000C000000070000001C010000F708000053070000390300000B040000D0020000DD04000018060000A203000018060000BC0700004605000000000000010000001C1400009D15000000000000060000000600000002000000020000001C0100000E090000000000000100000027140000700D000000000000060000000600000002000000020000001C010000F7080000010000000000000027140000E502000000000000000000000000000002000000020000001C010000F7080000000000000000000055320000BC19000000000000000000000D00000004000000040000001C010000F70800009B0A00008106000078563412040000004E00000001000000010000000B000000000000000100000002000000030000000400000005000000060000000700000008000000090000000A00000004000000640062006F0000000300000028753762000002000B00491F0000C4F0FFFF5C2B0000C4F0FFFF0000000002000000D4D0C80000000000000000000000000000000000010000000A000000000000004020000073F1FFFF230A00003E01000032000000010000020000230A00003E0100000200000000000500008008000080010000001500018600009001905F010004CBCECCE50F0046004B005F004300610072007300520075006E005F00430061007200730004000B00491F0000F0F1FFFF07250000F0F1FFFF07250000BAFAFFFF5C2B0000BAFAFFFF0000000002000000D4D0C80000000000000000000000000000000000010000000C00000000000000D81D0000CDF8FFFF840D00003E01000064000000010000020000840D00003E0100000200000000000500008008000080010000001500018600009001905F010004CBCECCE5140046004B005F0043006100720073004100630063006900640065006E0074005F00430061007200730004000B00491F00001CF3FFFF042400001CF3FFFF04240000CA0800005C2B0000CA0800000000000002000000D4D0C80000000000000000000000000000000000010000000E00000000000000D1150000F0FFFFFF840D00003E01000032000000010000020000840D00003E010000020000000000FFFFFF0008000080010000001500018600009001905F010004CBCECCE5140046004B005F00430061007200730042007200650061006B004C00610077005F00430061007200730004000B00491F00000AF6FFFF2A2300000AF6FFFF2A2300009C1800005C2B00009C1800000000000002000000D4D0C8000000000000000000000000000000000001000000100000000000000049140000290A0000320E00003E01000032000000010000020000320E00003E010000020000000000FFFFFF0008000080010000001500018600009001905F010004CBCECCE5150046004B005F0043006100720073005900650061007200410075006400690074005F00430061007200730004000B00DF1F00008EF9FFFFC52700008EF9FFFFC5270000B2F3FFFF5C2B0000B2F3FFFF0000000002000000D4D0C800000000000000000000000000000000000100000012000000000000007428000077F9FFFFD70C00003E01000032000000010000020000D70C00003E010000020000000000FFFFFF0008000080010000001500018600009001905F010004CBCECCE5130046004B005F004300610072007300520075006E005F0045006D0070006C006F0079006500650004000B00491F000002EFFFFF9D25000002EFFFFF9D25000038E6FFFF5C2B000038E6FFFF0000000002000000D4D0C800000000000000000000000000000000000100000014000000000000004C26000097EBFFFF2B0C00003E010000320000000100000200002B0C00003E010000020000000000FFFFFF0008000080010000001500018600009001905F010004CBCECCE5120046004B005F0043006100720073005200650070006100690072005F00430061007200730000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000300440064007300530074007200650061006D000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000160002000300000006000000FFFFFFFF00000000000000000000000000000000000000000000000000000000000000000000000015000000061500000000000053006300680065006D00610020005500440056002000440065006600610075006C0074000000000000000000000000000000000000000000000000000000000026000200FFFFFFFFFFFFFFFFFFFFFFFF0000000000000000000000000000000000000000000000000000000000000000000000001F0000001600000000000000440053005200450046002D0053004300480045004D0041002D0043004F004E00540045004E0054005300000000000000000000000000000000000000000000002C0002010500000007000000FFFFFFFF00000000000000000000000000000000000000000000000000000000000000000000000020000000BA0300000000000053006300680065006D00610020005500440056002000440065006600610075006C007400200050006F007300740020005600360000000000000000000000000036000200FFFFFFFFFFFFFFFFFFFFFFFF0000000000000000000000000000000000000000000000000000000000000000000000002F00000012000000000000000C00000073090000BEDAFFFF0100260000007300630068005F006C006100620065006C0073005F00760069007300690062006C0065000000010000000B0000001E000000000000000000000000000000000000006400000000000000000000000000000000000000000000000000010000000100000000000000000000000000000000000000D00200000600280000004100630074006900760065005400610062006C00650056006900650077004D006F006400650000000100000008000400000031000000200000005400610062006C00650056006900650077004D006F00640065003A00300000000100000008005600000036002C0030002C003200380034002C0030002C0032003200390035002C0031002C0031003800370035002C0032002C003800320035002C0035002C0031003200340035002C00310036002C0035003200330035000000200000005400610062006C00650056006900650077004D006F00640065003A00310000000100000008001E00000032002C0030002C003200380034002C0030002C0032003300330032000000200000005400610062006C00650056006900650077004D006F00640065003A00320000000100000008001E00000032002C0030002C003200380034002C0030002C0032003200390035000000200000005400610062006C00650056006900650077004D006F00640065003A00330000000100000008001E00000032002C0030002C003200380034002C0030002C0032003200390035000000200000005400610062006C00650056006900650077004D006F00640065003A00340000000100000008003E00000034002C0030002C003200380034002C0030002C0032003200390035002C00310032002C0032003700310035002C00310031002C0031003600360035000000020000000200000000000000000000000000000000000000D00200000600280000004100630074006900760065005400610062006C00650056006900650077004D006F006400650000000100000008000400000031000000200000005400610062006C00650056006900650077004D006F00640065003A00300000000100000008005600000036002C0030002C003200380034002C0030002C0032003200390035002C0031002C0031003800370035002C0032002C003800320035002C0035002C0031003200340035002C00310036002C0035003200330035000000200000005400610062006C00650056006900650077004D006F00640065003A00310000000100000008001E00000032002C0030002C003200380034002C0030002C0032003300330032000000200000005400610062006C00650056006900650077004D006F00640065003A00320000000100000008001E00000032002C0030002C003200380034002C0030002C0032003200390035000000200000005400610062006C00650056006900650077004D006F00640065003A00330000000100000008001E00000032002C0030002C003200380034002C0030002C0032003200390035000000200000005400610062006C00650056006900650077004D006F00640065003A00340000000100000008003E00000034002C0030002C003200380034002C0030002C0032003200390035002C00310032002C0032003700310035002C00310031002C0031003600360035000000030000000300000000000000000000000000000000000000D00200000600280000004100630074006900760065005400610062006C00650056006900650077004D006F006400650000000100000008000400000031000000200000005400610062006C00650056006900650077004D006F00640065003A00300000000100000008005600000036002C0030002C003200380034002C0030002C0032003200390035002C0031002C0031003800370035002C0032002C003800320035002C0035002C0031003200340035002C00310036002C0035003200330035000000200000005400610062006C00650056006900650077004D006F00640065003A00310000000100000008001E00000032002C0030002C003200380034002C0030002C0032003300330032000000200000005400610062006C00650056006900650077004D006F00640065003A00320000000100000008001E00000032002C0030002C003200380034002C0030002C0032003200390035000000200000005400610062006C00650056006900650077004D006F00640065003A00330000000100000008001E00000032002C0030002C003200380034002C0030002C0032003200390035000000200000005400610062006C00650056006900650077004D006F00640065003A00340000000100000008003E00000034002C0030002C003200380034002C0030002C0032003200390035002C00310032002C0032003700310035002C00310031002C0031003600360035000000040000000400000000000000000000000000000000000000D00200000600280000004100630074006900760065005400610062006C00650056006900650077004D006F006400650000000100000008000400000031000000200000005400610062006C00650056006900650077004D006F00640065003A00300000000100000008005600000036002C0030002C003200380034002C0030002C0032003200390035002C0031002C0031003800370035002C0032002C003800320035002C0035002C0031003200340035002C00310036002C0035003200330035000000200000005400610062006C00650056006900650077004D006F00640065003A00310000000100000008001E00000032002C0030002C003200380034002C0030002C0032003300310038000000200000005400610062006C00650056006900650077004D006F00640065003A00320000000100000008001E00000032002C0030002C003200380034002C0030002C0032003200390035000000200000005400610062006C00650056006900650077004D006F00640065003A00330000000100000008001E00000032002C0030002C003200380034002C0030002C0032003200390035000000200000005400610062006C00650056006900650077004D006F00640065003A00340000000100000008003E00000034002C0030002C003200380034002C0030002C0032003200390035002C00310032002C0032003700310035002C00310031002C0031003600360035000000050000000500000000000000000000000000000000000000D00200000600280000004100630074006900760065005400610062006C00650056006900650077004D006F006400650000000100000008000400000031000000200000005400610062006C00650056006900650077004D006F00640065003A00300000000100000008005600000036002C0030002C003200380034002C0030002C0032003200390035002C0031002C0031003800370035002C0032002C003800320035002C0035002C0031003200340035002C00310036002C0035003200330035000000200000005400610062006C00650056006900650077004D006F00640065003A00310000000100000008001E00000032002C0030002C003200380034002C0030002C0032003300330032000000200000005400610062006C00650056006900650077004D006F00640065003A00320000000100000008001E00000032002C0030002C003200380034002C0030002C0032003200390035000000200000005400610062006C00650056006900650077004D006F00640065003A00330000000100000008001E00000032002C0030002C003200380034002C0030002C0032003200390035000000200000005400610062006C00650056006900650077004D006F00640065003A00340000000100000008003E00000034002C0030002C003200380034002C0030002C0032003200390035002C00310032002C0032003700310035002C00310031002C0031003600360035000000060000000600000000000000000000000000000000000000D00200000600280000004100630074006900760065005400610062006C00650056006900650077004D006F006400650000000100000008000400000031000000200000005400610062006C00650056006900650077004D006F00640065003A00300000000100000008005600000036002C0030002C003200380034002C0030002C0032003200390035002C0031002C0031003800370035002C0032002C003800320035002C0035002C0031003200340035002C00310036002C0035003200330035000000200000005400610062006C00650056006900650077004D006F00640065003A00310000000100000008001E00000032002C0030002C003200380034002C0030002C0032003300330032000000200000005400610062006C00650056006900650077004D006F00640065003A00320000000100000008001E00000032002C0030002C003200380034002C0030002C0032003200390035000000200000005400610062006C00650056006900650077004D006F00640065003A00330000000100000008001E00000032002C0030002C003200380034002C0030002C0032003200390035000000200000005400610062006C00650056006900650077004D006F00640065003A00340000000100000008003E00000034002C0030002C003200380034002C0030002C0032003200390035002C00310032002C0032003700310035002C00310031002C0031003600360035000000070000000700000000000000000000000000000000000000D00200000600280000004100630074006900760065005400610062006C00650056006900650077004D006F006400650000000100000008000400000031000000200000005400610062006C00650056006900650077004D006F00640065003A00300000000100000008005600000036002C0030002C003200380034002C0030002C0032003200390035002C0031002C0031003800370035002C0032002C003800320035002C0035002C0031003200340035002C00310036002C0035003200330035000000200000005400610062006C00650056006900650077004D006F00640065003A00310000000100000008001E00000032002C0030002C003200380034002C0030002C0032003300310038000000200000005400610062006C00650056006900650077004D006F00640065003A00320000000100000008001E00000032002C0030002C003200380034002C0030002C0032003200390035000000200000005400610062006C00650056006900650077004D006F00640065003A00330000000100000008001E00000032002C0030002C003200380034002C0030002C0032003200390035000000200000005400610062006C00650056006900650077004D006F00640065003A00340000000100000008003E00000034002C0030002C003200380034002C0030002C0032003200390035002C00310032002C0032003700310035002C00310031002C0031003600360035000000080000000800000000000000000000000000000000000000D00200000600280000004100630074006900760065005400610062006C00650056006900650077004D006F006400650000000100000008000400000031000000200000005400610062006C00650056006900650077004D006F00640065003A00300000000100000008005600000036002C0030002C003200380034002C0030002C0032003200390035002C0031002C0031003800370035002C0032002C003800320035002C0035002C0031003200340035002C00310036002C0035003200330035000000200000005400610062006C00650056006900650077004D006F00640065003A00310000000100000008001E00000032002C0030002C003200380034002C0030002C0032003300310038000000200000005400610062006C00650056006900650077004D006F00640065003A00320000000100000008001E00000032002C0030002C003200380034002C0030002C0032003200390035000000200000005400610062006C00650056006900650077004D006F00640065003A00330000000100000008001E00000032002C0030002C003200380034002C0030002C0032003200390035000000200000005400610062006C00650056006900650077004D006F00640065003A00340000000100000008003E00000034002C0030002C003200380034002C0030002C0032003200390035002C00310032002C0032003700310035002C00310031002C0031003600360035000000090000000900000000000000300000000170C10F01000000640062006F00000046004B005F004300610072007300520075006E005F00430061007200730000000000000000000000C402000000000A0000000A00000009000000000000000000000000000000AD0F00000100000B0000000B000000000000003A0000000100000001000000640062006F00000046004B005F0043006100720073004100630063006900640065006E0074005F00430061007200730000000000000000000000C402000000000C0000000C0000000B000000000000000000000000000000AD0F00000100000D0000000D000000000000003A0000000100000001000000640062006F00000046004B005F00430061007200730042007200650061006B004C00610077005F00430061007200730000000000000000000000C402000000000E0000000E0000000D000000000000000000000000000000AD0F00000100000F0000000F000000000000003C0000000100000001000000640062006F00000046004B005F0043006100720073005900650061007200410075006400690074005F00430061007200730000000000000000000000C4020000000010000000100000000F000000000000000000000000000000AD0F0000010000110000001100000000000000380000000109C00F01000000640062006F00000046004B005F004300610072007300520075006E005F0045006D0070006C006F0079006500650000000000000000000000C40200000000120000001200000011000000000000000000000000000000AD0F0000010000130000001300000000000000360000000108C00F01000000640062006F00000046004B005F0043006100720073005200650070006100690072005F00430061007200730000000000000000000000C40200000000140000001400000013000000000000000000000000000000AD0F00000100001E00000013000000010000000400000043000000640000000F00000001000000060000005B0000004C0000000D0000000100000003000000510000004A0000000B00000001000000020000004D0000004E000000090000000100000005000000490000005A000000110000000700000005000000430000006400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000DBE6B0E91C81D011AD5100A0C90F57390000020080260199F8C7CF010202000010480500000000000000000000000000000000003A020000500072006F00760069006400650072003D00530051004C004F004C004500440042002E0031003B0049006E00740065006700720061007400650064002000530065006300750072006900740079003D0053005300500049003B005000650072007300690073007400200053006500630075007200690074007900200049006E0066006F003D00460061006C00730065003B0049006E0069007400690061006C00200043006100740061006C006F0067003D0053005400310032003B004400610074006100200053006F0075007200630065003D002E005C006700730071006C003B005500730065002000500072006F00630065006400750072006500200066006F007200200050007200650070006100720065003D0031003B004100750074006F0020005400720061006E0073006C006100740065003D0054007200750065003B005000610063006B00650074002000530069007A0065003D0034003000390036003B0057006F0072006B00730074006100740069006F006E002000490044003D0055005300450052002D00320030003100360031003100310037004D0042003B00550073006500200045006E006300720079007000740069006F006E00200066006F007200200044006100740061003D00460061006C00730065003B0054006100670020007700690074006800200063006F006C0075006D006E00200063006F006C006C006100740069006F006E0020007700680065006E00200070006F0073007300690062006C0065003D00460061006C007300650000000080050008000000FE56688831000000000226000A0000004300610072007300000008000000640062006F000000000226001A00000043006100720073004100630063006900640065006E007400000008000000640062006F000000000226001A000000430061007200730042007200650061006B004C0061007700000008000000640062006F00000000022600160000004300610072007300520065007000610069007200000008000000640062006F00000000022600100000004300610072007300520075006E00000008000000640062006F000000000226001C0000004300610072007300590065006100720041007500640069007400000008000000640062006F000000000226001200000045006D0070006C006F00790065006500000008000000640062006F000000000224000600000028753762000008000000640062006F000000000000000000010003000000000000000C0000000B00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000, N'3')
GO
GO
SET IDENTITY_INSERT [dbo].[dtproperties] OFF
GO

-- ----------------------------
-- Table structure for Employee
-- ----------------------------
DROP TABLE [dbo].[Employee]
GO
CREATE TABLE [dbo].[Employee] (
[员工编号] nvarchar(50) NOT NULL ,
[员工姓名] nvarchar(50) NULL ,
[入职日期] datetime NULL 
)


GO

-- ----------------------------
-- Records of Employee
-- ----------------------------
INSERT INTO [dbo].[Employee] ([员工编号], [员工姓名], [入职日期]) VALUES (N'E01', N'张三', N'2018-05-01 00:00:00.000')
GO
GO
INSERT INTO [dbo].[Employee] ([员工编号], [员工姓名], [入职日期]) VALUES (N'E02', N'李四', N'2018-08-02 00:00:00.000')
GO
GO
INSERT INTO [dbo].[Employee] ([员工编号], [员工姓名], [入职日期]) VALUES (N'E03', N'王五', N'2015-07-06 00:00:00.000')
GO
GO
INSERT INTO [dbo].[Employee] ([员工编号], [员工姓名], [入职日期]) VALUES (N'E04', N'刘六', N'2013-12-01 00:00:00.000')
GO
GO

-- ----------------------------
-- Table structure for PowerName
-- ----------------------------
DROP TABLE [dbo].[PowerName]
GO
CREATE TABLE [dbo].[PowerName] (
[ID] int NOT NULL ,
[PowerName] nvarchar(50) NULL 
)


GO

-- ----------------------------
-- Records of PowerName
-- ----------------------------
INSERT INTO [dbo].[PowerName] ([ID], [PowerName]) VALUES (N'1', N'管理员')
GO
GO
INSERT INTO [dbo].[PowerName] ([ID], [PowerName]) VALUES (N'2', N'录入人员')
GO
GO
INSERT INTO [dbo].[PowerName] ([ID], [PowerName]) VALUES (N'3', N'查询人员')
GO
GO
INSERT INTO [dbo].[PowerName] ([ID], [PowerName]) VALUES (N'4', N'领导')
GO
GO

-- ----------------------------
-- Table structure for RepairReport
-- ----------------------------
DROP TABLE [dbo].[RepairReport]
GO
CREATE TABLE [dbo].[RepairReport] (
[车牌号] nvarchar(50) NULL ,
[维修原因] nvarchar(50) NULL ,
[申请时间] nvarchar(50) NULL ,
[申请人] nvarchar(50) NULL ,
[审批结果] nvarchar(50) NULL 
)


GO

-- ----------------------------
-- Records of RepairReport
-- ----------------------------
INSERT INTO [dbo].[RepairReport] ([车牌号], [维修原因], [申请时间], [申请人], [审批结果]) VALUES (N'X003', N'保养', N'2018-05-07 22:18:31', N'xxx', N'拒绝-111')
GO
GO

-- ----------------------------
-- Table structure for TicketsDetail
-- ----------------------------
DROP TABLE [dbo].[TicketsDetail]
GO
CREATE TABLE [dbo].[TicketsDetail] (
[班次编号] int NULL ,
[姓名] nvarchar(50) NULL ,
[定金] int NULL ,
[未付] int NULL ,
[更新时间] nvarchar(50) NULL ,
[座位号] int NULL 
)


GO

-- ----------------------------
-- Records of TicketsDetail
-- ----------------------------
INSERT INTO [dbo].[TicketsDetail] ([班次编号], [姓名], [定金], [未付], [更新时间], [座位号]) VALUES (N'2', N'张三', N'20', N'0', N'2018-05-10 17:26:25', N'1')
GO
GO
INSERT INTO [dbo].[TicketsDetail] ([班次编号], [姓名], [定金], [未付], [更新时间], [座位号]) VALUES (N'3', N'李四', N'40', N'90', N'2018-05-10 17:45:12', N'1')
GO
GO
INSERT INTO [dbo].[TicketsDetail] ([班次编号], [姓名], [定金], [未付], [更新时间], [座位号]) VALUES (N'3', N'王五', N'40', N'90', N'2018-05-10 17:45:22', N'2')
GO
GO
INSERT INTO [dbo].[TicketsDetail] ([班次编号], [姓名], [定金], [未付], [更新时间], [座位号]) VALUES (N'4', N'陈拾', N'20', N'100', N'2018-05-20 17:50:47', N'1')
GO
GO
INSERT INTO [dbo].[TicketsDetail] ([班次编号], [姓名], [定金], [未付], [更新时间], [座位号]) VALUES (N'4', N'郑玖', N'20', N'100', N'2018-05-20 18:06:23', N'2')
GO
GO

-- ----------------------------
-- Table structure for 用户
-- ----------------------------
DROP TABLE [dbo].[用户]
GO
CREATE TABLE [dbo].[用户] (
[用户名] nvarchar(50) NULL ,
[密码] nvarchar(50) NULL ,
[权限] int NULL ,
[姓名] nvarchar(50) NULL ,
[电话] nvarchar(50) NULL ,
[EMAIL] nvarchar(50) NULL 
)


GO

-- ----------------------------
-- Records of 用户
-- ----------------------------
INSERT INTO [dbo].[用户] ([用户名], [密码], [权限], [姓名], [电话], [EMAIL]) VALUES (N'admin', N'123', N'3', N'管理员', N'234', null)
GO
GO
INSERT INTO [dbo].[用户] ([用户名], [密码], [权限], [姓名], [电话], [EMAIL]) VALUES (N'xxx', N'123', N'2', N'张家祥', null, null)
GO
GO
INSERT INTO [dbo].[用户] ([用户名], [密码], [权限], [姓名], [电话], [EMAIL]) VALUES (N'yyy', N'123', N'4', N'刘王五', null, null)
GO
GO
INSERT INTO [dbo].[用户] ([用户名], [密码], [权限], [姓名], [电话], [EMAIL]) VALUES (N'lingdao', N'123', N'11', N'领导', N'12', N'')
GO
GO

-- ----------------------------
-- Indexes structure for table Cars
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table Cars
-- ----------------------------
ALTER TABLE [dbo].[Cars] ADD PRIMARY KEY ([车牌号])
GO

-- ----------------------------
-- Indexes structure for table CarsAccident
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table CarsAccident
-- ----------------------------
ALTER TABLE [dbo].[CarsAccident] ADD PRIMARY KEY ([ID])
GO

-- ----------------------------
-- Indexes structure for table CarsBreakLaw
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table CarsBreakLaw
-- ----------------------------
ALTER TABLE [dbo].[CarsBreakLaw] ADD PRIMARY KEY ([ID])
GO

-- ----------------------------
-- Indexes structure for table CarsRepair
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table CarsRepair
-- ----------------------------
ALTER TABLE [dbo].[CarsRepair] ADD PRIMARY KEY ([ID])
GO

-- ----------------------------
-- Indexes structure for table CarsRun
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table CarsRun
-- ----------------------------
ALTER TABLE [dbo].[CarsRun] ADD PRIMARY KEY ([ID])
GO

-- ----------------------------
-- Indexes structure for table CarsYearAudit
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table CarsYearAudit
-- ----------------------------
ALTER TABLE [dbo].[CarsYearAudit] ADD PRIMARY KEY ([ID])
GO

-- ----------------------------
-- Indexes structure for table CarTickets
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table CarTickets
-- ----------------------------
ALTER TABLE [dbo].[CarTickets] ADD PRIMARY KEY ([班次编号])
GO

-- ----------------------------
-- Indexes structure for table CharteredCar
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table CharteredCar
-- ----------------------------
ALTER TABLE [dbo].[CharteredCar] ADD PRIMARY KEY ([预定编号])
GO

-- ----------------------------
-- Indexes structure for table dtproperties
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table dtproperties
-- ----------------------------
ALTER TABLE [dbo].[dtproperties] ADD PRIMARY KEY ([id], [property])
GO

-- ----------------------------
-- Indexes structure for table Employee
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table Employee
-- ----------------------------
ALTER TABLE [dbo].[Employee] ADD PRIMARY KEY ([员工编号])
GO

-- ----------------------------
-- Indexes structure for table PowerName
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table PowerName
-- ----------------------------
ALTER TABLE [dbo].[PowerName] ADD PRIMARY KEY ([ID])
GO

-- ----------------------------
-- Foreign Key structure for table [dbo].[CarsAccident]
-- ----------------------------
ALTER TABLE [dbo].[CarsAccident] ADD FOREIGN KEY ([车牌号]) REFERENCES [dbo].[Cars] ([车牌号]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO

-- ----------------------------
-- Foreign Key structure for table [dbo].[CarsBreakLaw]
-- ----------------------------
ALTER TABLE [dbo].[CarsBreakLaw] ADD FOREIGN KEY ([车牌号]) REFERENCES [dbo].[Cars] ([车牌号]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO

-- ----------------------------
-- Foreign Key structure for table [dbo].[CarsRepair]
-- ----------------------------
ALTER TABLE [dbo].[CarsRepair] ADD FOREIGN KEY ([车牌号]) REFERENCES [dbo].[Cars] ([车牌号]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO

-- ----------------------------
-- Foreign Key structure for table [dbo].[CarsRun]
-- ----------------------------
ALTER TABLE [dbo].[CarsRun] ADD FOREIGN KEY ([车牌号]) REFERENCES [dbo].[Cars] ([车牌号]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO
ALTER TABLE [dbo].[CarsRun] ADD FOREIGN KEY ([员工编号]) REFERENCES [dbo].[Employee] ([员工编号]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO

-- ----------------------------
-- Foreign Key structure for table [dbo].[CarsYearAudit]
-- ----------------------------
ALTER TABLE [dbo].[CarsYearAudit] ADD FOREIGN KEY ([车牌号]) REFERENCES [dbo].[Cars] ([车牌号]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO
